Minimum (fld), Minimum (fld, condFld), Minimum (fld, condFld, cond), Minimum (x)
Basic and Crystal syntax.
Arguments
- fld is any valid database or formula field that can be evaluated by the function.
- condFld is a field used to group the values in fld by.
- cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime or Boolean field. For more information on the valid strings for this argument, see Conditions for summary functions.
- x is an array of values that can be evaluated by the function being used.
Returns
Fractional Number
Action
Enables you to find the minimum value that appears in a set of values. For example:
- If a sales report includes a field that shows the amount of each order, you can find the lowest order amount of all the orders that appear on the report (a grand total minimum amount). For information on finding this kind of minimum, see SummaryFunction (fld).
- If you break orders into groups (for example, orders grouped by the state that they come from), you can find the lowest order amount per group (in this case, per state). For information on finding this kind of minimum, see SummaryFunction (fld, condFld).
- If you break orders into date or Boolean groups (for example, orders grouped by the month in which they were placed), you can find the lowest order amount per group based on a specific change in the date or Boolean field (in this case, per month). For information on finding this kind of minimum, see SummaryFunction (fld, condFld, cond).
- If you specify a set of individual values, you can find the lowest value in the set. For information on finding this kind of minimum, see Array summary functions (x).
Examples
The following examples are applicable to both Basic and Crystal syntax:
Minimum({file.QTY})
Returns the lowest value in the QTY field.
Minimum({orders.AMOUNT}, {orders.CUSTOMER ID})
Identifies the smallest order in each group of orders in the Amount field (the smallest order for each month). The orders are separated into groups whenever the value in the Customer ID field changes.
Minimum({orders.AMOUNT}, {orders.ORDER DATE}, "monthly")
Identifies the smallest order in each group of orders in the Amount field (the smallest order for each month). The orders are separated into groups whenever the value in the Date field changes to a new month.
The following example is applicable to Crystal syntax:
Minimum also allows you to set a ceiling on a calculation. For example: Minimum([{file.COMMISSION}, 2500]) returns the commission accrued up to a cap or ceiling of 2500. Once accrued commission passes the $2500 mark, this expression returns 2500. Thus:
Minimum([{file.COMMISSION}, 2500])
Returns 1575 where commission = 1575.
Note: Using this function in a formula forces the formula to be evaluated at print time.
For more information on evaluation time considerations, see Evaluation Time functions.